<%@ page import="java.util.List" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.util.ArrayList" %>
<%@ page import="edu.sctu.User" %><%--
  Created by IntelliJ IDEA.
  User: LENOVO
  Date: 2018/5/17
  Time: 16:17
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"  %>
<html>
  <head>
    <title></title>
  </head>
  <body>
  <style type="text/css">

      table {

          border-collapse: collapse;
      }

      td {
          border: 1px solid #000;
          padding: 10px;
      }
  </style>
  <table>
      <tr>
          <td>编号</td>
          <td>用户名</td>
          <td>密码</td>
          <td>操作1</td>
          <td>操作2</td>
      </tr>


<%

//class User{
//    int id;
//    String name;
//    String password;
//}

    //数据库中读取数据保存在List集合中
    List<User> userList=new ArrayList<User>();


  //3+1读取数据库数据保存到List中
  Connection connection=null;
  Statement statement=null;
  ResultSet resultSet=null;


  String sql="select * from t_users";

  Class.forName("com.mysql.jdbc.Driver");


  connection= DriverManager.getConnection(
          "jdbc:mysql://localhost:3306/sctu_javaweb_2018?serverTimezone=UTC",
          "root",
          "123456"
  );

  statement=connection.createStatement();
  resultSet=statement.executeQuery(sql);

  while(resultSet.next()){
      int id=resultSet.getInt(1);
      String name=resultSet.getString(2);
      String password=resultSet.getString(3);

      User user = new User();

      user.setId(id);
      user.setName(name);
      user.setPassword(password);

//      user.id = id;
//      user.name = name;
//      user.password = password;

      userList.add(user);
  }


  resultSet.close();
  statement.close();
  connection.close();

    request.setAttribute("userList", userList);

%>


   <c:forEach var="user" items="${userList}">
       <tr>
           <td>${user.id}</td>
           <td>${user.name}</td>
           <td>${user.password}</td>
           <td><a href="">删除</a> </td>
           <td><a href="">更新</a> </td>
       </tr>
   </c:forEach>


  </table>


  <%--案例--%>
  <%--<%--%>

  <%--<c:forEach var="i" begin="0" end="9">--%>
      <%--<p>${i}</p>--%>
  <%--</c:forEach>--%>


  <%--for (int i=0;i<10;i++){--%>
  <%--out.write("<p>"+i+"</P>");--%>
    <%--}--%>
<%--%>--%>


  </body>
</html>
